SELECT * FROM ip_properties WHERE prActive = 1 AND (prLocation LIKE '{1eee73216a2e02b72c46fbacd83662f058458571cd4714c806b0458f0db2b68a}Cancelada{1eee73216a2e02b72c46fbacd83662f058458571cd4714c806b0458f0db2b68a}' OR prCity = 'Cancelada' OR prZip = 'Cancelada' OR prStreet LIKE '{1eee73216a2e02b72c46fbacd83662f058458571cd4714c806b0458f0db2b68a}Cancelada{1eee73216a2e02b72c46fbacd83662f058458571cd4714c806b0458f0db2b68a}' OR prCountry = 'Cancelada') AND (prLocation LIKE '{1eee73216a2e02b72c46fbacd83662f058458571cd4714c806b0458f0db2b68a}Spain{1eee73216a2e02b72c46fbacd83662f058458571cd4714c806b0458f0db2b68a}' OR prCity = 'Spain' OR prZip = 'Spain' OR prStreet LIKE '{1eee73216a2e02b72c46fbacd83662f058458571cd4714c806b0458f0db2b68a}Spain{1eee73216a2e02b72c46fbacd83662f058458571cd4714c806b0458f0db2b68a}' OR prCountry = 'Spain')